RM_Class_MSTR (RM00201)

azurecurve Products Microsoft Dynamics GP (0)SalesRM_Class_MSTR (RM00201)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM00201

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM_Class_MSTR
Physical Name: RM00201
Technical Name: RM_Class_MSTR

Group Display Name: Receivables Class Master Files
Group Technical Name: RM_Class_MSTR_Logical_File

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CLASSID	Class ID	String	STR15_LBAU	15
2	CLASDSCR	Class Description	String	STR30	30
3	CRLMTTYP	Credit Limit Type	Integer	GB_Amt_Type	0
4	CRLMTAMT	Credit Limit Amount	Currency	DLR17_RBS0_UTR$	17
5	CRLMTPER	Credit Limit Period	Integer	DDL	0
6	CRLMTPAM	Credit Limit Period Amount	Currency	DLR17_RBS0_UTR$	17
7	DEFLTCLS	Default Class	Boolean	CB_Default	0
8	BALNCTYP	Balance Type	Integer	GB_Bal_Type	0
9	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['RM_Class_MSTR'].CHEKBKID AS 'RM_Class_MSTR-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM RM00201 AS ['RM_Class_MSTR'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['RM_Class_MSTR'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
10	BANKNAME	Bank Name	String	STR30	30
11	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['RM_Class_MSTR'].TAXSCHID AS 'RM_Class_MSTR-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM RM00201 AS ['RM_Class_MSTR'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['RM_Class_MSTR'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
12	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['RM_Class_MSTR'].SHIPMTHD AS 'RM_Class_MSTR-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM RM00201 AS ['RM_Class_MSTR'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['RM_Class_MSTR'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
13	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['RM_Class_MSTR'].PYMTRMID AS 'RM_Class_MSTR-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM RM00201 AS ['RM_Class_MSTR'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['RM_Class_MSTR'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
14	CUSTDISC	Customer Discount	Integer	INT5_%2	5
15	CSTPRLVL	Customer Price Level	String	STR10	10
16	MINPYTYP	Minimum Payment Type	Integer	GB_Amt_Type	0
17	MINPYDLR	Minimum Payment Dollar	Currency	DLR17_RBS0_UTR$	17
18	MINPYPCT	Minimum Payment Percent	Integer	INT5_%2	5
19	MXWOFTYP	Maximum Writeoff Type	Integer	GP_Max_Writeoff	0
20	MXWROFAM	Max Writeoff Amount	Currency	DLR17_RBS0_UTR$	17
21	FINCHARG	Finance Charge	Boolean	CB_Finance_Charge	0
22	FNCHATYP	Finance Charge Amt Type	Integer	GB_Amt_Type	0
23	FINCHDLR	Finance Charge Dollar	Currency	DLR17_RBS0_UTR$	17
24	FNCHPCNT	Finance Charge Percent	Integer	INT5_%2	5
25	PRCLEVEL	PriceLevel	String	STR10_LBAU	10
26	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['RM_Class_MSTR'].CURNCYID AS 'RM_Class_MSTR-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM RM00201 AS ['RM_Class_MSTR'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['RM_Class_MSTR'].CURNCYID = ['Currency Setup'].CURNCYID
27	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['RM_Class_MSTR'].RATETPID AS 'RM_Class_MSTR-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM RM00201 AS ['RM_Class_MSTR'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['RM_Class_MSTR'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
28	DEFCACTY	Default Cash Account Type	Integer	GB	0
29	RMCSHACC	RM Cash Account Index	Long Integer	LI_14	14
30	RMARACC	RM AR Account Index	Long Integer	LI_14	14
31	RMCOSACC	RM Cost Of Sales Account Index	Long Integer	LI_14	14
32	RMIVACC	RM IV Account Index	Long Integer	LI_14	14
33	RMSLSACC	RM Sales Account Index	Long Integer	LI_14	14
34	RMAVACC	RM Discounts Avail Account Index	Long Integer	LI_14	14
35	RMTAKACC	RM Discounts Taken Account Index	Long Integer	LI_14	14
36	RMFCGACC	RM Finance Charge Account Index	Long Integer	LI_14	14
37	RMWRACC	RM Writeoff Account Index	Long Integer	LI_14	14
38	RMSORACC	RM Sales Order Returns Account Index	Long Integer	LI_14	14
39	SALSTERR	Sales Territory	String	STR15_Sales_Territory	15
	Key to the Sales Territory Master File (RM00303). Click to show/hide SELECT ['RM_Class_MSTR'].SALSTERR AS 'RM_Class_MSTR-Sales Territory' ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory' FROM RM00201 AS ['RM_Class_MSTR'] INNER JOIN RM00303 AS ['Sales Territory Master File'] ON ['RM_Class_MSTR'].SALSTERR = ['Sales Territory Master File'].SALSTERR
40	SLPRSNID	Salesperson ID	String	STR15_Salesperson_ID	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['RM_Class_MSTR'].SLPRSNID AS 'RM_Class_MSTR-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM RM00201 AS ['RM_Class_MSTR'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['RM_Class_MSTR'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
41	STMTCYCL	Statement Cycle	Integer	DDL_Stmt_Cycle	0
42	SNDSTMNT	Send Statement	Boolean	CB_Send_Statement	0
43	INACTIVE	Inactive	Boolean	CB_Inactive	0
44	KPCALHST	Keep Calendar History	Boolean	CB_Keep_Calendar_History	0
45	KPDSTHST	Keep Distribution History	Boolean	CB_Keep_Dist_History	0
46	KPERHIST	Keep Period History	Boolean	CB_Keep_Period_History	0
47	KPTRXHST	Keep Trx History	Boolean	CB_Keep_Trx_History	0
48	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['RM_Class_MSTR'].NOTEINDX AS 'RM_Class_MSTR-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM RM00201 AS ['RM_Class_MSTR'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['RM_Class_MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX
49	MODIFDT	Modified Date	Date	DT	8
50	CREATDDT	Created Date	Date	DT	8
51	Revalue_Customer	Revalue Customer	Boolean	CB Revalue Customer	0
52	Post_Results_To	Post Results To	Integer	GB	0
53	DISGRPER	Discount Grace Period	Integer	INT2_U0	2
54	DUEGRPER	Due Date Grace Period	Integer	INT2_U0	2
55	ORDERFULFILLDEFAULT	Order Fulfillment Shortage Default	Integer	DDL_OrderFulfillDefault	0
56	CUSTPRIORITY	Customer Priority	Integer	DDL_CustomerPriority	0
57	RMOvrpymtWrtoffAcctIdx	RM Overpayment Writeoff Account Index	Long Integer	LI_14	14
58	CBVAT	Cash Based VAT	Boolean	CB_CashBasedVAT	0
59	INCLUDEINDP	Include in Demand Planning	Boolean	CB_IncludeInDemandPlanning	0

azurecurve Products Microsoft Dynamics GP (0)SalesRM_Class_MSTR (RM00201)

Leave a Reply Cancel reply